package cn.mothin.dao;
 
import java.util.List;

import org.springframework.stereotype.Repository;

import cn.mothin.entity.SystemUserRole;
import cn.mothin.frame.core.base.BaseDao;
@Repository ("169a25bb-878a-4316-850f-bf0818ef63cc")
public class SystemUserRoleDao extends BaseDao<SystemUserRole>{ 
	public void removeAll(String userId) {
		String sql = "DELETE FROM system_user_role WHERE systemUserId=?";
		sqlHelper.execute(sql, userId);
	}

	public List<SystemUserRole> findSystemUserRoles(String userId) {
		String sql = "SELECT * FROM system_user_role WHERE systemUserId=?";
		return query(sql, userId);
	}
}
